package com.trkj.dao.hjj;

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.Slotcarddate;
/**
 * 刷卡数据列表
 * @author HJJ
 *
 */
public interface CreditCardDataDAO extends CrudRepository<Slotcarddate, Long> {
	@Query("select s,st from Slotcarddate s right join s.staffInformation st")
	public List<Object[]> findAllslo(Pageable p);
	
	@Query("select s,st from Slotcarddate s inner join  s.staffInformation st where st.stainId=?1")
	public List<Object[]> findSloBySid(Long stainId);
}
